﻿CREATE TABLE [dbo].[SalaryRequest] (
    [Id]                      UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL,
    [RefNumber]               NVARCHAR (50)    NOT NULL,
    [PayrollDate]             DATE             NOT NULL,
    [TotalValue]              MONEY            NULL,
    [SalaryCurrencyId]        UNIQUEIDENTIFIER NULL,
    [CurrencyConvertedTo]     UNIQUEIDENTIFIER NULL,
    [ExchangeRateId]          UNIQUEIDENTIFIER NULL,
    [Remarks]                 NTEXT            NULL,
    [MBCurrency]              UNIQUEIDENTIFIER NULL,
    [MBTotal]                 MONEY            NULL,
    [PreparedBy]              UNIQUEIDENTIFIER NOT NULL,
    [ReviewedBy]              UNIQUEIDENTIFIER NULL,
    [AuthorizedBy]            UNIQUEIDENTIFIER NULL,
    [CountryProgrammeId]      UNIQUEIDENTIFIER NULL,
    [PreparedOn]              DATETIME         NULL,
    [ReviewedOn]              DATETIME         NULL,
    [AuthorizedOn]            DATETIME         NULL,
    [RejectReviewRemarks]     NVARCHAR (350)   NULL,
    [RejectAuthorizedRemarks] NVARCHAR (250)   NULL,
    [IsReviewed]              BIT              NULL,
    [IsAuthorized]            BIT              NULL,
    [TotalPayroll]            MONEY            NULL,
    [PayrollYear]             INT              NULL,
    [PayrollMonth]            NVARCHAR (50)    NULL
);

